Tabela InvoiceStatus

Definicja tabeli InvoiceStatus

Name

InvoiceStatus

Code

InvoiceStatus

Comment

 


Lista kolumn tabeli InvoiceStatus

Name

Code

InvoiceStatusID

InvoiceStatusID

InvoiceID

InvoiceID

MessageID

MessageID

DrugInvoiceID

DrugInvoiceID

Status

Status

PerfDT

PerfDT

InvoiceState

InvoiceState

VersionNo

VersionNo


Kolumna InvoiceStatusID tabeli InvoiceStatus

Definicja kolumny InvoiceStatusID tabeli InvoiceStatus

Name

InvoiceStatusID

Code

InvoiceStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InvoiceID tabeli InvoiceStatus

Definicja kolumny InvoiceID tabeli InvoiceStatus

Name

InvoiceID

Code

InvoiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MessageID tabeli InvoiceStatus

Definicja kolumny MessageID tabeli InvoiceStatus

Name

MessageID

Code

MessageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DrugInvoiceID tabeli InvoiceStatus

Definicja kolumny DrugInvoiceID tabeli InvoiceStatus

Name

DrugInvoiceID

Code

DrugInvoiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Status tabeli InvoiceStatus

Definicja kolumny Status tabeli InvoiceStatus

Name

Status

Code

Status

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli InvoiceStatus

Definicja kolumny PerfDT tabeli InvoiceStatus

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna InvoiceState tabeli InvoiceStatus

Definicja kolumny InvoiceState tabeli InvoiceStatus

Name

InvoiceState

Code

InvoiceState

Data Type

VARCHAR2(1024)

Mandatory

No

Comment

 


Kolumna VersionNo tabeli InvoiceStatus

Definicja kolumny VersionNo tabeli InvoiceStatus

Name

VersionNo

Code

VersionNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli InvoiceStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli InvoiceStatus

Definicja klucza Identifier_1 tabeli InvoiceStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment